Print

Use Data from an External Workbook

1. Choose Spreadsheets > Manage Links.

The Manage Links form appears.

2. If the sheet to which you want to link is not available in the Sheets pane, select it by clicking the check box.
3. The sheet of the Internal workbook opens in the viewer.
4. In the Workbooks pane, click Add Workbook.

The Open Workbook form appears.

5. Select the workbook that contains the data you want to link to your scenario.
6. Click Open.

The external workbook is loaded, the sheets of the workbook appear in the Sheets pane, and the first sheet opens in the viewer.

7. Click the Internal workbook.
8. Click the sheet within which you want to set up the link.
9. Click the cell in which you want to set up the link.
10. Type the formula, including the reference to the cell of the external workbook to which you want to link.

For example, if you want to the data in the cell to be the same as the data in a call of the external workbook, use the formula =workbook_cell_reference.

Note: If you are linking a cell that contains a date from the external workbook, the date must be reformatted as text and it is good practice to prefix the data with the term "date". You do this using the formula =CONCATENATE("date",TEXT(workbook_cell_reference,"dd/mm/yyyy")).

11. Press ENTER.
12. Set up any other links you want to make to the external workbook.
13. Click OK.